create or replace procedure p_insert_project_member(p_available_start_date in date,
                                                    p_available_end_date   in date,
                                                    p_resource_id          in number,
                                                    p_project_id           in number,
                                                    pout_id                out number) is
begin
  insert into project_members
    (available_start_date,
     available_end_date,
     resource_id,
     project_id)
  values
    (p_available_start_date,
     p_available_end_date,
     p_resource_id,
     p_project_id)
  returning id into pout_id;
end;
/
